create or replace procedure p_insert_project_activity(p_estimated_start_date in date,
                                                      p_estimated_end_date   in date,
                                                      p_project_id           in number,
                                                      p_activity_id          in number,
                                                      pout_id                out number) is
begin
  insert into project_activities
    (estimated_start_date, estimated_end_date, project_id, activity_id)
  values
    (p_estimated_start_date,
     p_estimated_end_date,
     p_project_id,
     p_activity_id)
  returning id into pout_id;
end;
/
